﻿CREATE TABLE [dbo].[CartItems] (
    [cartItemID]              UNIQUEIDENTIFIER NOT NULL,
    [cartID]                  UNIQUEIDENTIFIER NOT NULL,
    [inventoryItemByVendorID] BIGINT           NOT NULL,
    [itemPrice]               DECIMAL (5, 2)   NOT NULL,
    [quantity]                DECIMAL (5, 2)   NOT NULL,
    [itemDiscountQuant]       DECIMAL (5, 2)   NULL,
    [itemDiscountPerc]        DECIMAL (3, 2)   NULL,
    [itemExtendedPrice]       DECIMAL (5, 2)   NOT NULL
);





